<?php

$installer = $this;

$installer->startSetup();

$installer->run("
DROP TABLE IF EXISTS {$this->getTable('inchoo_cat_images')};
CREATE TABLE {$this->getTable('inchoo_cat_images')} (
  `img_id` int(5) NOT NULL auto_increment,
  `img_name` varchar(64) default NULL,
  `img_label` varchar(256) default NULL,
  `img_linkt` varchar(256) default NULL,
  `img_des` text default NULL,
  `category_id` int(5) default NULL,
  `img_order` int(5) default NULL,
  PRIMARY KEY  (`img_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

insert  into {$this->getTable('inchoo_cat_images')}(`img_id`,`img_name`,`img_label`,`img_linkt`,`img_des`,`category_id`,`img_order`) values (1,'/b/l/blank.png','Blank','','',1,1);

DROP TABLE IF EXISTS {$this->getTable('inchoo_categories')};
CREATE TABLE {$this->getTable('inchoo_categories')} (
  `cat_id` int(5) NOT NULL auto_increment,
  `cat_name` varchar(32) default NULL,
  PRIMARY KEY  (`cat_id`),
  UNIQUE KEY `category` (`cat_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

insert  into {$this->getTable('inchoo_categories')}(`cat_id`,`cat_name`) values (1,'Demo');

");

$installer->endSetup();